Charting on an OLAP cube (OLAP layout)

The OLAP layout lets you chart on an OLAP grid. In order to create an OLAP chart, you must first have an OLAP grid in your report. For more information, see Creating an OLAP report.

To chart on an OLAP cube
  1. Select the OLAP grid on which you want to chart.
  2. On the Insert menu, click Chart. The Chart Expert dialog box appears.

    Tip:     Another way to do this is to click the Insert Chart button on the Standard toolbar.

  3. On the Type tab, in the Chart type list, select a chart type. Then click the chart subtype that best illustrates your data. See Chart types.
  4. Select Automatically set chart options if you want the Chart Expert to use the default options on the Axes and Options tabs.

    Note:    If you want to select options on the Axes and Options tabs manually, ensure that "Automatically set chart options" is not selected.

  5. Click the Data tab.

  6. In the Layout area, click the OLAP button, if it is not already selected.
  7. In the Placement area, click Header or Footer to specify where to place your chart.

    Note:    The frequency with which your chart appears in the report depends on the report section that the OLAP grid has been placed in.

  8. In the Data area, in the On change of list, click the field you want to base your chart on.
  9. If necessary, in the Subdivided by list, click a secondary row or column you want to base your chart on.

    Note:    Be sure that the chart type selected in Step 3 supports a secondary charting field.

  10. If the Axes and Options tabs appear, you can customize some of the chart's properties, such as the scaling of the axes, the legend, and the data points.
  11. Click the Text tab.

    Accept the default title information or add new titles to your chart.

  12. Click OK.

Your chart is placed in the Header or Footer section of the report, depending on your selection in Step 7. You may have to refresh your report to preview the finished chart.

Note:    When your chart is inserted, it may cover a portion of the report. Move and resize the chart so that it fits properly within the report.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com